package jdbc;

import java.sql.Connection;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;

public class Test {
    public static void main(String[] args) {
        try (
                Connection conn = DBUtil.getConnection();
        ) {
//            Scanner scan = new Scanner(System.in);
//            System.out.println("请输入要删除的用户");
//            String username = scan.nextLine();
            UserInfo userInfo= InputUtil.getInputObject(new UserInfo(),"删除用户","删除");
            Statement statement = conn.createStatement();
            String str  = "DELETE FROM userinfo WHERE username = '"+userInfo.getUsername()+"'";
            int num = statement.executeUpdate(str);
            System.out.println("删除"+(num>0?"成功":"失败"));

        } catch (Exception e) {
            throw new RuntimeException(e);
        }
    }
}
